class AddSearchMetaDataAndFixSomeStuff < ActiveRecord::Migration
  def self.up
    add_column :projects, :shead, :string
    add_column :projects, :sbody, :string
    add_column :projects, :smeta, :string
    add_column :action_items, :shead, :string
    add_column :action_items, :sbody, :string
    add_column :action_items, :smeta, :string
    add_column :contacts, :shead, :string
    add_column :contacts, :sbody, :string
    add_column :contacts, :smeta, :string
    add_column :funds, :shead, :string
    add_column :funds, :sbody, :string
    add_column :funds, :smeta, :string
    add_column :line_items, :shead, :string
    add_column :line_items, :sbody, :string
    add_column :line_items, :smeta, :string  
    add_column :line_item_entries, :amount, :integer      
  end

  def self.down
    remove_column :projects, :shead
    remove_column :projects, :sbody
    remove_column :projects, :smeta
    remove_column :action_items, :shead
    remove_column :action_items, :sbody
    remove_column :action_items, :smeta
    remove_column :contacts, :shead
    remove_column :contacts, :sbody
    remove_column :contacts, :smeta
    remove_column :funds, :shead
    remove_column :funds, :sbody
    remove_column :funds, :smeta
    remove_column :line_items, :shead
    remove_column :line_items, :sbody
    remove_column :line_items, :smeta
    remove_column :line_item_entries, :amount
  end
end
